{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["March 13c"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"March 13c","index":0,"n_rows":40,"n_cols":35,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,0,0,29],[6,30,7,30],[6,31,7,31]]}
["March 13 Calculator"]
[null,"q1","q2","q3","q4","q5","q6","q7","q8","q9","q10","q11ac","q11b,c","q12","q13a","q13b","q14a","q14b","q15","q16a","q16b","q17","q18","q19","q20","q21","q22","q23","q24","q25"]
[null,"Stem and Leaf ","Proportion Recipe Questions ","AO3 Multiplication Problem","Probability and Relative Frequency","Area and Circumference of Circles","Percentages ","Compound Measures","Trial and Improvement ","Volume of a Prism","Translations ","Probability and Problem Solving","Expand & Factorise Quadratics","midpoint","Pythagoras' Theorem","Trigonometry","Substitution","More Difficult Rearranging Formulae","Similar Shapes","Percentages ","Compound Interest & Depreciation","Using a Calculator","Box plots","Area of Sector & Length of Arcs","Money problem Solving",{"$error":"#N/A"},"Spheres and Cones","Stratified Sampling","Upper and Lower Bounds","More Difficult Rearranging Formulae"]
["Max Mark",3,3,4,5,3,5,4,4,3,2,2,4,4,3,3,2,3,5,3,3,2,5,2,3,4,4,2,5,5]
["Class Average (%)",{"$f":"AVERAGE(B9:B40)/B$4","v":0.54761904761904756},{"$f":"AVERAGE(C9:C40)/C$4","v":0.5},0.44642857142857145,0.4642857142857143,0.40476190476190471,0.45,0.42857142857142855,0.4017857142857143,0.44047619047619047,0.5357142857142857,0.5357142857142857,0.5714285714285714,0.4107142857142857,0.54761904761904756,0.51190476190476197,0.5357142857142857,0.52380952380952384,0.56428571428571428,0.55952380952380953,0.54761904761904756,0.5178571428571429,0.42142857142857143,0.4642857142857143,0.54761904761904756,0.4375,0.6160714285714286,0.44642857142857145,0.42142857142857143,0.47142857142857142]
["Standard Deviation",{"$f":"STDEV(B9:B39)/B$4","v":0.39767105659499585},{"$f":"STDEV(C9:C39)/C$4","v":0.35717225040714645},0.27518632456485409,0.29840847683606281,0.33156497426229203,0.31564161580759537,0.27094777801764386,0.25765399669048805,0.30162210882402518,0.35819949512370658,0.40662503039522213,0.2793605699491753,0.33481812167679126,0.35386502872393577,0.27936056994917519,0.38317802236740667,0.27857029801244837,0.34876956811082532,0.35199106129423313,0.31706324373711398,0.34646743359179161,0.3142977390677012,0.38317802236740672,0.35386502872393577,0.32364389438141788,0.32971749170862069,0.39297737457927134,0.32358769245599361,0.3137079827047734]
[null,"q1","q2","q3","q4","q5","q6","q7","q8","q9","q10","q11ac","q11b,c","q12","q13a","q13b","q14a","q14b","q15","q16a","q16b","q17","q18","q19","q20","q21","q22","q23","q24","q25","Total Marks","Grade"]
["Name"]
["Sample student 1",{"$f":"ROUND(RAND()*B$4,0)","v":2},{"$f":"ROUND(RAND()*C$4,0)","v":3},2,3,2,2,3,1,0,1,1,3,3,3,1,1,2,4,3,0,1,1,1,0,1,3,2,2,5,{"$f":"IF(AD9=\"\",\"\",SUM(B9:AD9))","v":56},{"$f":"IF(AD9=\"\",\"\",VLOOKUP(AE9,$AH$13:$AI$34,2))","v":"B3"}]
["Sample student 2",{"$f":"ROUND(RAND()*B$4,0)","v":0},1,2,5,1,3,2,0,1,1,0,2,2,2,1,1,2,1,0,2,1,5,0,1,1,2,0,3,3,{"$f":"IF(AD10=\"\",\"\",SUM(B10:AD10))","v":45},{"$f":"IF(AD10=\"\",\"\",VLOOKUP(AE10,$AH$13:$AI$34,2))","v":"C1"},null,"Grade Boundaries"]
["Sample student 3",2,3,0,0,0,4,3,1,2,2,2,3,3,2,1,2,3,4,1,3,0,4,1,2,3,0,2,4,3,{"$f":"IF(AD11=\"\",\"\",SUM(B11:AD11))","v":60},"B2"]
["Sample student 4",3,1,4,2,0,2,0,2,1,2,1,3,4,2,1,2,2,1,2,1,1,2,0,3,2,4,2,4,3,57,"B3",null,"Non- Calc"]
["Sample student 5",2,0,2,1,1,5,2,3,1,1,0,3,0,2,2,2,2,1,3,2,1,4,1,3,1,4,0,2,0,51,"B3",null,0,"F3"]
["Sample student 6",0,1,1,2,2,2,2,0,3,1,1,1,4,1,2,1,0,4,2,3,1,1,1,0,3,3,2,1,5,50,"C1",null,{"$f":"AH13+(AH16-AH13)/3","v":2.3333333333333335},"F2"]
["Sample student 7",1,1,2,3,2,3,1,0,0,0,0,3,0,0,1,2,2,5,3,2,1,3,1,1,1,3,0,0,3,44,"C2",null,{"$f":"AH13+2*(AH16-AH13)/3","v":4.666666666666667},"F1"]
["Sample student 8",1,2,3,0,0,3,1,1,2,0,2,2,2,1,2,0,1,2,2,3,1,1,0,2,4,2,1,5,3,49,"C1",null,7,"E3"]
["Sample student 9",3,0,1,5,1,1,0,2,{"$f":"ROUND(RAND()*J$4,0)","v":3},1,2,1,3,1,3,1,3,4,0,2,2,5,1,1,2,4,2,1,3,58,"B2",null,{"$f":"AH16+(AH19-AH16)/3","v":10},"E2"]
["Sample student 10",2,2,0,2,1,2,2,3,1,2,2,1,2,3,2,1,1,2,3,2,0,3,2,1,1,0,0,0,1,44,"C2",null,{"$f":"AH16+2*(AH19-AH16)/3","v":13},"E1"]
["Sample student 11",3,2,2,1,2,0,3,2,0,1,2,3,2,1,1,0,3,5,2,1,1,2,1,3,1,3,0,0,3,50,"C1",null,16,"D3"]
["Sample student 12",0,2,1,2,3,1,1,2,1,1,2,0,2,3,1,1,1,4,3,1,1,3,0,1,3,1,1,1,2,45,"C1",null,{"$f":"AH19+(AH22-AH19)/3","v":21.333333333333332},"D2"]
["Sample student 13",3,2,1,2,1,1,0,3,2,1,2,2,0,2,2,0,1,5,3,1,1,5,2,1,1,1,1,2,1,49,"C1",null,{"$f":"AH19+2*(AH22-AH19)/3","v":26.666666666666664},"D1"]
["Sample student 14",0,2,2,0,0,3,2,3,2,1,0,3,3,1,1,2,2,3,2,2,0,0,2,2,2,3,1,3,3,50,"C1",null,32,"C3"]
["Sample student 15",1,1,2,3,3,2,3,2,2,0,1,2,2,3,1,1,0,4,2,2,1,0,2,2,4,4,1,1,5,57,"B3",null,{"$f":"AH22+(AH25-AH22)/3","v":38.333333333333336},"C2"]
["Sample student 16",3,2,1,2,1,0,2,3,3,1,0,1,4,1,3,1,1,0,3,0,2,1,1,2,3,4,2,4,3,54,"B3",null,{"$f":"AH22+2*(AH25-AH22)/3","v":44.666666666666664},"C1"]
["Sample student 17",2,1,2,1,1,2,1,1,0,1,2,4,1,0,0,0,2,2,0,3,2,0,2,1,3,3,1,4,0,42,"C2",null,51,"B3"]
["Sample student 18",{"$f":"ROUND(RAND()*B$4,0)","v":3},3,2,2,2,5,2,2,1,0,1,1,0,1,2,0,2,2,2,2,2,2,0,1,2,3,1,1,1,48,"C1",null,{"$f":"AH25+(AH28-AH25)/3","v":57.333333333333336},"B2"]
["Sample student 19",3,3,1,3,0,1,4,0,1,2,1,1,0,1,1,2,1,2,2,2,1,0,0,3,0,1,1,3,4,44,"C2",null,{"$f":"AH25+2*(AH28-AH25)/3","v":63.666666666666664},"B1"]
["Sample student 20",3,0,0,3,0,0,1,3,1,0,1,2,0,3,2,1,1,1,1,2,1,3,2,0,1,2,0,0,0,34,"C3",null,70,"A3"]
["Sample student 21",0,1,2,2,1,1,1,1,2,0,1,1,2,1,3,1,2,1,1,1,0,3,2,2,3,1,0,0,2,38,"C3",null,{"$f":"AH28+(AH31-AH28)/3","v":75},"A2"]
["Sample student 22",2,3,4,4,0,2,3,3,1,1,0,2,2,3,1,2,1,0,1,0,1,2,1,3,0,1,1,0,3,47,"C1",null,{"$f":"AH28+2*(AH31-AH28)/3","v":80},"A1"]
["Sample student 23",2,1,0,0,1,5,1,1,1,2,1,2,1,3,2,0,2,0,0,2,2,0,1,1,0,2,0,4,4,41,"C2",null,85," A*3"]
["Sample student 24",1,3,3,4,0,4,1,2,0,1,0,4,0,1,2,0,1,5,0,1,0,2,0,{"$f":"ROUND(RAND()*Y$4,0)","v":3},0,4,2,2,3,49,"C1",null,{"$f":"AH31+(AH34-AH31)/3","v":90},"A*2"]
["Sample student 25",3,0,3,1,2,1,2,1,2,2,1,3,1,3,1,2,{"$f":"ROUND(RAND()*R$4,0)","v":3},5,1,1,1,2,0,3,2,1,0,4,2,53,"B3",null,{"$f":"AH31+2*(AH34-AH31)/3","v":95},"A*1"]
["Sample student 26",0,0,2,4,3,4,0,1,1,1,2,4,1,0,0,1,1,5,2,2,2,1,1,3,1,2,1,1,0,46,"C1",null,100,"A*1"]
["Sample student 27",1,2,3,4,2,4,3,1,1,2,0,3,0,0,3,1,1,4,1,3,0,1,1,0,4,4,0,4,0,53,"B3"]
["Sample student 28",0,0,2,4,2,0,2,1,2,2,2,4,2,2,1,2,1,3,2,0,2,3,0,1,0,4,1,3,1,49,"C1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AD37=\"\",\"\",SUM(C37:AD37))","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]